Main Memory Database TPC-H Workload Characterization on Modern Processor
نویسندگان
چکیده
منابع مشابه
Modern Main-Memory Database Systems
This tutorial provides an overview of recent developments in mainmemory database systems. With growing memory sizes and memory prices dropping by a factor of 10 every 5 years, data having a “primary home” in memory is now a reality. Main-memory databases eschew many of the traditional architectural tenets of relational database systems that optimized for disk-resident data. Innovative approache...
متن کاملMain Memory DBMS on Modern Processors, a Simulation Approach for Database Performance Characterization
Database applications are an important type of workloads that is very different from other types of application workloads such as SPEC benchmarks. In the past, much research has been devoted to evaluate performance characteristics of database workloads on various processor architectures. While most of the previous performance evaluations have been done using hardware counters, many recently dev...
متن کاملOptimizing Main-Memory Join on Modern Hardware
ÐIn the past decade, the exponential growth in commodity CPU's speed has far outpaced advances in memory latency. A second trend is that CPU performance advances are not only brought by increased clock rate, but also by increasing parallelism inside the CPU. Current database systems have not yet adapted to these trends and show poor utilization of both CPU and memory resources on current hardwa...
متن کاملMultidimensional Database Design via Schema Transformation: Turning TPC-H into the TPC-H*d Multidimensional Benchmark
Compared to relational databases, multidimensional database systems enhance data presentation and navigation through intuitive spreadsheet like views and increase performance through aggregated data. In this paper, we present a framework for automating multidimensional database schema design. We successfully used the framework to revolve the well known TPC-H benchmark to become a multidimension...
متن کاملOn Workload Characterization of Relational Database Environments
As relational database systems become increasingly popular, there is a clear need to better understand the workload so systems can be designed or tuned more eeectively. A RElational Database Workload AnalyzeR (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where an SQL trace for a two hour interval and an image copy of th...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Software
سال: 2008
ISSN: 1000-9825
DOI: 10.3724/sp.j.1001.2008.02573